﻿CREATE TABLE [dbo].[Vaga] (
    [Id]                         INT            IDENTITY (1, 1) NOT NULL,
    [IdEmpresa]                  INT            NOT NULL,
    [IdSelecionador]             INT            NOT NULL,
    [IdCargo]                    INT            NOT NULL,
    [IdFormaContratacao]         INT            NOT NULL,
    [IdNivelProfissional]        INT            NOT NULL,
    [DivulgarDadosEmpresa]       BIT            NOT NULL,
    [DivulgarVagaRH]             BIT            NOT NULL,
    [Valor]                      MONEY          NULL,
    [ValorMinimo]                MONEY          NULL,
    [ValorMaximo]                MONEY          NULL,
    [Descricao]                  VARCHAR (1024) NOT NULL,
    [DataInclusao]               DATETIME       NOT NULL,
    [DataExpiracao]              DATETIME       NULL,
    [TempoEntrevista]            DECIMAL (2, 2) NULL,
    [EmpresaAberta]              BIT            NULL,
    [MesmaLocalizacaoEmpresa]    BIT            NOT NULL,
    [IdBairro]                   INT            NULL,
    [TempoExperienciaMinimo]     NUMERIC (3)    NULL,
    [TipoTempoExperienciaMinimo] CHAR (1)       NULL,
    [TempoExperienciaMaximo]     NUMERIC (3)    NULL,
    [TipoTempoExperienciaMaximo] CHAR (1)       NULL,
    [Status]                     CHAR (1)       NOT NULL,
    [DeficienteFisico]           BIT            NOT NULL,
    FOREIGN KEY ([IdNivelProfissional]) REFERENCES [dbo].[NivelProfissional] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION
);





